Custom Properties for Organizations

Custom properties for organizations allow you to define and track attributes at the customer or site level. These fields provide flexibility to capture business-specific information that applies across multiple devices or service groups.

Examples

  • Region or location

  • Support level or SLA tier

  • Compliance status

  • Contract type

How They Work in Analytics

The Analytics Data Warehouse stores organization-level custom properties as key-value pairs, allowing you to capture business-specific attributes for customers or sites.

Where to Find the Latest Values

  • SRC_CUSTOM_PROPERTY_ORG_VALUE_LATEST

    Contains the most recent values for all organization-level custom properties.

  • SRC_CUSTOM_PROPERTY_ORG_LATEST

    Holds the definitions of organization-level custom properties, including property names and IDs.

Access Through Direct Data Access (DDA)

You can query these tables using DDA in Snowflake to:

  • Retrieve the latest custom property values for customers or sites.

  • Join with other datasets using CUSTOMER_DK for organization-level analysis.

  • Apply advanced transformations such as pivoting or creating dynamic tables to reshape data for reporting and compliance dashboards.

Linking these queries to datasets where CUSTOMER_DK is unique ensures accurate joins and prevents duplication.

Boilerplate query for organizations

Use this query to retrieve the latest value of a specific custom property for each organization (customer or site) from the Analytics Data Warehouse. This query is designed for Direct Data Access (DDA) and links property definitions to their values, returning the organization key, property name, and current value. It provides a reliable starting point for custom reporting and integration.

Copy 
Select v.customer_dk, p.name, v.value 
From SHARED_ANALYTICS_DATA.SHARED_DATA.SRC_CUSTOM_PROPERTY_ORG_VALUE_LATEST v
Join SHARED_ANALYTICS_DATA.SHARED_DATA.SRC_CUSTOM_PROPERTY_ORG_LATEST p
on p.custom_property_dk = v.custom_property_dk
where p.name = 'Your Custom Property of Interest';

Here’s what each part does:

Element Description
SELECT v.customer_dk, p.name, v.value customer_dk: Unique key for each organization (customer or site).p.name: Name of the custom property (e.g., “Region” or “Support Level”).v.value: Current value assigned to that property for the organization.
FROM SRC_CUSTOM_PROPERTY_ORG_VALUE_LATEST v Stores the latest values for all organization-level custom properties.
JOIN SRC_CUSTOM_PROPERTY_ORG_LATEST p ON p.custom_property_dk = v.custom_property_dk Contains the definitions of organization-level custom properties (names, IDs).The join links property values to their property names using custom_property_dk.
WHERE p.name = 'Your Custom Property of Interest' Filters the results to only include rows for the specified custom property.

You can safely link this query to any dataset where CUSTOMER_DK is unique. For more advanced scenarios, Snowflake offers powerful transformation options. For example, you can use PIVOT to turn property names into columns or create dynamic tables to automate reshaping and aggregation. These techniques help organize custom property data for reporting and analysis. The exact approach will depend on your data architecture and reporting requirements.